use table locks to prevent stale reads from trigger [MRXN23-572]

use table locks to prevent stale reads from trigger [MRXN23-572] #1478