Can we have the xstore and xcenter data consistency for employee password?

How can we configure the employee passwords consistent across the organization?

The employee has multiple passwords with multiple entries found for “current_password_flag =1” in xcenter DB, whereas in store DB only one password has “current_password_flag =1”.

And the Xstore and Xcenter will not be in sync due to network issues, so the client is asking for logic to handle this issue. Please advise what options will be to resolve this systematically and without manual intervention

In this case, how can we maintain consistency?

Xcenter DB:

Store DB: