UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7W27Kb9su+Kn6tW59SZF86z98rp1hT+rGTneO2IcAwI='
WHERE
key_id = 'b368435c8de002f24a8ae5ebd4bec1afb4324d85c409e4dfb2549a70b24988de'
AND (
token = '7W27Kb9su+Kn6tW59SZF86z98rp1hT+rGTneO2IcAwI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)