Systems and methods for updating payment card expiration information

A computer system for synchronizing distributed databases including a first database associated with a first merchant and a second database associated with an issuer party, said computer system comprising:

• a payment processing computing device in communication with at least one memory device for storing payment card information and transaction information, the payment processing computing device configured to:
• select, from the at least one memory device, a candidate payment card having stale payment card information including an existing expiration date and an account identifier;
• perform a lookup in at least one memory device using the account identifier;
• retrieve at least one transaction record from the at least one memory device corresponding to a recent transaction performed using the candidate payment card at a second merchant;
• determine that the at least one retrieved transaction record includes updated expiration date data;
• generate an updated expiration date notification;
• transmit the updated expiration date notification to a first merchant computer associated with the first merchant, the updated expiration date notification indicating that the existing expiration date has been replaced with the updated expiration date;
• and
• cause, by the transmission, the distributed databases to be synchronized by updating the first database and the second database.

A payment processing computing device for synchronizing distributed databases including a first database associated with a first merchant and a second database associated with an issuer party, the payment processing computing device in communication with at least one memory device for storing payment card information and transaction information, the payment processing computing device configured to:

• select, from the at least one memory device, a candidate payment card having stale payment card information including an existing expiration date and an account identifier;
• perform a lookup in the at least one memory device using the account identifier;
• retrieve at least one transaction record from the at least one memory device corresponding to a recent transaction performed using the candidate payment card at a second merchant;
• determine that the at least one retrieved transaction record includes updated expiration date data;
• generate an updated expiration date notification;
• transmit the updated expiration date notification to a first merchant computer associated with a first merchant, the updated expiration date notification indicating that the existing expiration date has been replaced with the updated expiration date;
• and
• cause, by the transmission, the distributed databases to be synchronized by updating the first database and the second database.

One or more non-transitory computer-readable storage media having computer-executable instructions embodied thereon for synchronizing distributed databases including a first database associated with a first merchant and a second database associated with an issuer party, the computer-executable instructions configured to be executed by at least one processor communicatively coupled to at least one memory device for storing payment card information and transaction information, the computer-executable instructions cause the processor to:

• select, from the at least one memory device, a candidate payment card having stale payment card information including an existing expiration date and an account identifier;
• perform a lookup in the at least one memory device using the account identifier;
• retrieve at least one transaction record from the at least one memory device corresponding to a recent transaction performed using the candidate payment card at a second merchant;
• determine that the at least one retrieved transaction record includes updated expiration date data;
• generate an updated expiration date notification;
• transmit the updated expiration date notification to a first merchant computer associated with the first merchant, the updated expiration date notification indicating that the existing expiration date has been replaced with the updated expiration date;
• and
• cause, by the transmission, the distributed databases to be synchronized by updating the first database and the second database.