UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8P9Xv/XdhFbx9/P3IeImjG6G02PovOgOinupry1IYZ8='
WHERE
key_id = '1dd698e41f5cb42f0cf32dcf2a14091bebb20daae11476e49340b100ec71cfbf'
AND (
token = '8P9Xv/XdhFbx9/P3IeImjG6G02PovOgOinupry1IYZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)