[Backport stable/8.1] fix: db transaction inconsistencies when deleting keys

[backport-action]

Description

Backport of #1139 to stable/8.1.

relates to camunda/zeebe-process-test#1001 #1001

[github-actions[bot]]

Test Results

 50 files  ±0   50 suites  ±0   1m 43s :stopwatch: -19s 107 tests +2  107 :white_check_mark: +2  0 :zzz: ±0  0 :x: ±0  344 runs  +6  344 :white_check_mark: +6  0 :zzz: ±0  0 :x: ±0 

Results for commit 45ee3682. ± Comparison against base commit 11c62756.

[zeebe-bors-camunda[bot]]

Build succeeded:

• Test summary