UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z7WlCpaQFllwInuNjHa6mryRV8ytYRXu2fIm4+rp1Xo='
WHERE
key_id = 'b9aee76f56c19ba7fe4bf4954f91aab8445e2a16d3308594cbcddacc01422074'
AND (
token = 'z7WlCpaQFllwInuNjHa6mryRV8ytYRXu2fIm4+rp1Xo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)