fix tests and CI

this MR adds new test environments and fixes some issues within the test suite, especially the incompatibility with tox-current-env 0.0.11 and tox 4.18.0. and we switch to python 3.10

assigned to @Chilipp

enabled an automatic merge when the pipeline for 09bcbce8 succeeds

merged

aborted the automatic merge because source branch was updated

added 2 commits

• a70c4eb5 - update lockfiles
• 55ae0be1 - remove link to deployed flood-event-explorer

Compare with previous version

enabled an automatic merge when the pipeline for 55ae0be1 succeeds

mentioned in commit b707f887