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