Just add a function so when you change your profile, it also pulls all records that match md5(userid, password) and then update them records too.

Though I’m convinced the overarching logic is correct, this is not my wheelhouse, so I’m probably wrong.