There are quite some tutorials for OTA programming of ESP32 with WIFI connection but I haven’t seen one for cellular connection using popular modules like the SIM800.
A very good course is this one on Udemy:
Are there already ways to connect the ESP32 over cellular to OTA with Mongoose?
In particular, I have in mind using the board from lilygo:
Best and thank you!