UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0QZdjD5Im1ehz0oyDJBMu5K2icWxtDMR3YYirfrE3Vo='
WHERE
key_id = '2b9acfce85da698be75298701b2b5599438c0fd470b9b3decfb804c5fd92fe62'
AND (
token = '0QZdjD5Im1ehz0oyDJBMu5K2icWxtDMR3YYirfrE3Vo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)