UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LQeCVxo2N4NLllPGS+hJN6CdUlJLyyex8ENOcYP6KYU='
WHERE
key_id = 'd7a464879833f70a87566c66e8fa9eadebdd78e0a6295264318f6626fd27c788'
AND (
token = 'LQeCVxo2N4NLllPGS+hJN6CdUlJLyyex8ENOcYP6KYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)