Purging rooms can be cancelled by the Postgres statement timeout

[reivilibre]

As noticed in #16193 (v1.90.0)

We need a statement timeout override for the relevant bits of purging so that we can still purge large rooms.

(Ideally we might make it more incremental and avoid the long transactions, but that luxury would take more time)