Can an active sex life affect herniated discs at s1-l5 ?

It should not: Paying attention to proper body mechanics, and avoiding very extreme positions will minimize low back issues. But normal active sexual activities should not have any effect on l5-s1 herniated disc.

Probably ok: Unless you are in severe pain that limits you, it should be ok. Would just be reasonable and listen to your body. Have fun.