Do not lock when creating a new archive id

By using a sequence table. refs #6417 
i guess `PREFIX_SQL_LOCK` is now unused and can be removed