Cancelled transaction still returned from /transactions endpoint

[acha-bill]

Context

v2.5.0

Summary

Canceling a pending transaction does not remove it from the pending store unless you send another transaction, like buying a stamp.

Expected behavior

If a pending transaction is cancelled, it should immediately be removed from the pending store. /transactions should not return it anymore.

Actual behavior

After a pending transaction is cancelled, it still shows up in /transactions response.

Steps to reproduce

1. Create any tx and verify it's pending with /transactions
2. Cancel it
3. Call /transactions again and the cancelled tx is still there

Possible solution

[Cafe137]

May be related to https://github.com/ethersphere/bee/issues/5123 ?