Fix SBoM ingestion deadlock

What does this MR do and why?

Fix SBoM ingestion deadlock (#404630 (closed))

Rewrite the upsert queries so that they perform updates in a consistent order. This should prevent deadlocking when multiple concurrent transactions are trying to update the same rows.

See: #404630 (comment 1438682895)

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.