UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YIHn4yicpxChoruR6Q1wCH7Fh4jD5zgoMF99kzt7Z0M='
WHERE
key_id = 'ac4da1d59bcdc2c614a81cb856fc4f6393a60dca5f35d7dff7bcfd2bc959116b'
AND (
token = 'YIHn4yicpxChoruR6Q1wCH7Fh4jD5zgoMF99kzt7Z0M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)