Refactor update_service_instances_max_storage_mb

* Updating max_storage_mb for all service instances using
* a sub query generated from the catalog.

[#67082390]