You can update the CODESYS program through LAN2 regardless of it’s IP subnet in relation to LAN1, provided you allow CODESYS login through LAN2 in the HMI setup.
Still doesn’t sound like that will help you though as all other devices on your router are not in the subnet needed for SQL, and you cannot update the EB program through LAN1 when using CODESYS.