Fix bug with concurrent upload of manifests

Previously a UNIQUE constraint failed: blob.name error could occur
if two idential (but differently tagged) manifests or two manifests
referencing the same blob were uploaded at the same time.

This has been resolved by ensuring that the entirety of the manifest
upload completion code is executed under exclusive database lock.

Bug: T366856