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