UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5B+wR4O6vJ61GhK4LvoWWvaZ5YOlmqvFqYJL5jPNlS4='
WHERE
key_id = 'af271c0ad9cdbe63e62387103ce577596f0d88315caf51a1f4446493e274a074'
AND (
token = '5B+wR4O6vJ61GhK4LvoWWvaZ5YOlmqvFqYJL5jPNlS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)