Best all-round lens (plus possible telephoto) for Sony ZV-E10

Hey everyone, I’m currently using a Sony ZV-E10, mainly for cinematic-style videos (mostly for advertising content for my business). I also use it occasionally for photography – mostly urban/street shots or portraits of friends.

Right now, I only have the kit lens and a cheap manual 25mm f/1.8 lens that I use for a more cinematic look.

I’m looking to upgrade to a high-quality, sharp all-rounder lens – preferably with autofocus and suitable for both video and photo work. Additionally, I’d be interested in a secondary lens with a longer focal length for sports photography (mainly football). Ideally, I’d love something that could cover both use cases to some extent.

My budget is around €300–400 used – so used options are totally fine.

Any recommendations?

Thanks in advance!