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