UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6FsOeg6AcMeScNjAkzIK7rsUORAcXfYGloeVEfeUo3E='
WHERE
key_id = 'e492c5e17a51e84cecc6ff69fdc250414c78e8225601d2afc34bbea216405ce5'
AND (
token = '6FsOeg6AcMeScNjAkzIK7rsUORAcXfYGloeVEfeUo3E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)