>Well, while I'm doing this process, I must lock the record, this way no user will generate the same ID.

You could always use GUIDs.