UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y8qaFVGG0kJPhYIkpe05GFKW2XkXTjthSxCCs7xrgtY='
WHERE
key_id = 'cdd1c896f6c30b9db599c2c611c42354b92885f1ea52202f6b2bea84037bc684'
AND (
token = 'Y8qaFVGG0kJPhYIkpe05GFKW2XkXTjthSxCCs7xrgtY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)