UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tTaOtMRhTIwjqJb0PWfjaNORcXZiSb4hWa6RsTt1wJk='
WHERE
key_id = '505d9f3faa1384d210c612844b193cc8cd7695a7806ad5fbeb0ccd97957644b3'
AND (
token = 'tTaOtMRhTIwjqJb0PWfjaNORcXZiSb4hWa6RsTt1wJk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)