UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '40CRcJz1K66wDRP1Y60LSLvCegPbpX6bS326oMQXiyw='
WHERE
key_id = 'e126b788cf3a987810a3e9b20aaf8410675af3ac977047e67c06358db0ff249a'
AND (
token = '40CRcJz1K66wDRP1Y60LSLvCegPbpX6bS326oMQXiyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)