Reduce code duplication in payment related code

[stevenbal]

From https://github.com/open-formulieren/open-forms/pull/4583#discussion_r1705422339

There's a few places where we filter on payments that are "successful", this logic should probably be part of the queryset to avoid duplication