Not with one statement. You’ll have to delete them individually.

Cant we do this with a script? where the conditions are checked then based on that the delete function will run, or create a view where these records which needs to be deleted are shown, then use that view in a script to delete all from that view every day.