Implement scan operation level lock

**Description:**
Currently in the scan manager we have a global level lock when updating the scan table. Need to change this to a scan operation level lock.

**Suggested Labels:**

**Suggested Assignees:**

**Affected Product Version:**

**OS, DB, other environment details and versions:**

**Steps to reproduce:**


**Related Issues:**
