UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Ck7gIVyg2DvRoTTHMswwtGAQBYF8HFu5/BzmvRlGC8='
WHERE
key_id = '37686c657b718ce4c1eabe363132aba596c0978b0a484b4cc9da0c4300778c8e'
AND (
token = '7Ck7gIVyg2DvRoTTHMswwtGAQBYF8HFu5/BzmvRlGC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)