UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XHtQUHit1R27dlQKlqElw4qbm3EHB0qx1XEaJ64snNI='
WHERE
key_id = '9db7cdf82644911c281445f68e658d1296703bf078d4d5cc455187b7e352c44c'
AND (
token = 'XHtQUHit1R27dlQKlqElw4qbm3EHB0qx1XEaJ64snNI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)