UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zdi9Y5uNnMA7tvob935dFyT8KDBr7Oe44VzoCYs83p8='
WHERE
key_id = '00277bd7cc3779d054ec0da5caf7fcb228acf0e72e3a4daa18f0bf02b72f0b72'
AND (
token = 'Zdi9Y5uNnMA7tvob935dFyT8KDBr7Oe44VzoCYs83p8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)