UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YkSWELYyW08wsl71Kd48xWP2SHT8O98faYLA+inYXnM='
WHERE
key_id = 'be0dc9f6a9a2f71cdbc038b60c9014974137eef79921719185b516569aafec7e'
AND (
token = 'YkSWELYyW08wsl71Kd48xWP2SHT8O98faYLA+inYXnM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)