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