UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7N6efwo+cj496tPAwS8NykzClfX3RW+wz8rRt0NHN28='
WHERE
key_id = '338a9c83ecdcfb52f9907e8ad59347ec5ce5dde9a2ed25915509288dd95d2d0b'
AND (
token = '7N6efwo+cj496tPAwS8NykzClfX3RW+wz8rRt0NHN28='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)