UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6WQqDLZzLDs4h1NpI2zYEqKtFY3ySo85gNq4lbfkEoA='
WHERE
key_id = '3c21f79688be844824e1be76f97c5900e18f24864616abb6ae34616b86104e2b'
AND (
token = '6WQqDLZzLDs4h1NpI2zYEqKtFY3ySo85gNq4lbfkEoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)