UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h4Sh/GsbyJVb8xRKMgNSHrt5QZDB7eiEy6zE1IW7Mg0='
WHERE
key_id = '878c8982399c825efee6f5552479d5c2aa4178f2314e7e5b4098a86c829c24e6'
AND (
token = 'h4Sh/GsbyJVb8xRKMgNSHrt5QZDB7eiEy6zE1IW7Mg0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)