UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MzPq3a3lsZIe2oif82cB/GWqxEvw41OOBAJsRS8FVh4='
WHERE
key_id = '4ec7acdf4d6dc8c2a60fef3d4f6ca48d6ad8f9ab99c5b4069db63abe7ca0bede'
AND (
token = 'MzPq3a3lsZIe2oif82cB/GWqxEvw41OOBAJsRS8FVh4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)