UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AZ2/vY9jLDHN5zQdgQUAwIfgDuUtLRfF4cBpT8fXyOg='
WHERE
key_id = 'af194bf7bd4a5f81a34aecdf46601577ef6afd6cf7a7c4535e3c3740c85b39c2'
AND (
token = 'AZ2/vY9jLDHN5zQdgQUAwIfgDuUtLRfF4cBpT8fXyOg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)