UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bTLyRdRZRY0ubNoDcccxn6LvoYQNCz+GAvd6nuZCZTA='
WHERE
key_id = 'f2a8cd28a183eb2d27a85250fd644403ed23154604c095d03e68784e5a8a97ee'
AND (
token = 'bTLyRdRZRY0ubNoDcccxn6LvoYQNCz+GAvd6nuZCZTA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)