The longest true thunderbolt 4 cable you can have is 3 meters or a bit under 10 ft.

I guess you could try making some kind of thunderbolt 4 media converter and do it over fiber, but R&D would probably be pretty steep.

There are optical Thubderbolt 3 cables made by Corning/Wero up 100m ($$$$). While not TB4, I've used regular TB3 cables with TB4 devices without issue. I assume it would be similar for those optical cables given same bandwidth requirements. I've also seen TB4 5m cables being sold with the listing saying they are rated up to 30gbps instead of 40.