state invoice change in mysql

Doing this via DB queries is definitely not recommended...
But basically, you can invoke the following code if you still decide to pursue this approach:

\Drupal::entityTypeManager()->getStorage('commerce_invoice')->resetCache(['<the invoice ID>']);

Replace "the invoice ID" by the invoice ID of course :).

Automatically closed - issue fixed for 2 weeks with no activity.