UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MCA95G4jkeIt03/guOTEGj+KCxyMR/KbH0X8VSn6g+k='
WHERE
key_id = 'b2835fca6eb61585263d9a73f02c738de20a38a6bceb7c4957e6953df18e70c4'
AND (
token = 'MCA95G4jkeIt03/guOTEGj+KCxyMR/KbH0X8VSn6g+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)