UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q+UQ2YmkJzuyWpESNjxCze1ySk+ginPVsoXgIy0Fkvs='
WHERE
key_id = 'dc894f9a1d97d137b861a5be6a08548ac191730e36c89e1cd369bf2e4aaa4107'
AND (
token = 'q+UQ2YmkJzuyWpESNjxCze1ySk+ginPVsoXgIy0Fkvs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)