UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r34kbBkhiCI+0s90NmUqY7Tx/0/Cxm/3At4HZw+1f94='
WHERE
key_id = 'd6ce462b157df7c587f787533d58374d7abcb0ff08218f177893605fd0e2db9f'
AND (
token = 'r34kbBkhiCI+0s90NmUqY7Tx/0/Cxm/3At4HZw+1f94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)