storagemgr: Fix transaction handling

In MaybeUpdateRepositoryKey, we rollback the transaction in a defer statement. This would return error if the transaction is committed. Instead we should rollback if there was an error.