UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Q3Q+V3aPVunbTUDJMt8QLyEr5yT1mXwH1QT/UFkIOY='
WHERE
key_id = 'cd01572d0aee637527445f35591ff0bd0971b3826565049c5f44120294b46ffe'
AND (
token = '6Q3Q+V3aPVunbTUDJMt8QLyEr5yT1mXwH1QT/UFkIOY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)