/inventory-storage/bound-withs assumes that no other process touches the records involved. This cannot be guaranteed and may cause roll backs or unique violation exceptions (race condition).
The validation, the INSERT and the DELETE should be in the same transaction.
FOR KEY SHARE is needed to prevent a roll-back if some other process wants to delete the item or the holding.
RETURNING jsonb is needed to return the changed elements for the Kafka messages.