json Formatında veri Güncelleyip Ekleme Yardım

Aşağıdaki gibi bir veriye sahibim mysql kullanarak aşadağıdaki verileri private_id ye göre güncellemek istiyorum bunu nasıl yapabilirim veya buraya nasıl json decode yapmadan veri eklemesi yapabilirim

[ {
"id": 4709,
"private_id": 163773379011,
"Date": "2016-09-18",
"Appendix": 7197,
"Text": "R5vC",
"Reconciliation_account": "E7r31g",
"creditor": 9417,
"debtor": 3689,
"accountno": 2666,
"vat": "b2MB",
"invoice": 7088,
"sag": 156
},
{
"id": 6335,
"private_id": 202892445730,
"Date": "2021-03-23",
"Appendix": 4314,
"Text": "yY6YJ",
"Reconciliation_account": "JOeTrF",
"creditor": 8486,
"debtor": 3235,
"accountno": 4652,
"vat": "8dSVbO",
"invoice": 8839,
"sag": 457
},
{
"id": 6189,
"private_id": 230477168617,
"Date": "2019-07-30",
"Appendix": 2482,
"Text": "CoUk0S",
"Reconciliation_account": "j7nPKI",
"creditor": 3278,
"debtor": 7739,
"accountno": 3893,
"vat": "mEILfE",
"invoice": 266,
"sag": 814
},
{
"id": 4770,
"private_id": 763308707268,
"Date": "2019-07-11",
"Appendix": 9108,
"Text": "LrR3sw",
"Reconciliation_account": "GFGW1G",
"creditor": 4594,
"debtor": 8500,
"accountno": 1918,
"vat": "8X9ws",
"invoice": 3045,
"sag": 8688
},
{
"id": 7812,
"private_id": 508374787584,
"Date": "2016-11-11",
"Appendix": 3173,
"Text": "fsTR",
"Reconciliation_account": "4UdsSA",
"creditor": 8123,
"debtor": 6667,
"accountno": 7522,
"vat": "lAsA",
"invoice": 2973,
"sag": 9896
}
]

data = [{
    "id": 4709,
    "private_id": 163773379011,
    "Date": "2016-09-18",
    "Appendix": 7197,
    "Text": "R5vC",
    "Reconciliation_account": "E7r31g",
    "creditor": 9417,
    "debtor": 3689,
    "accountno": 2666,
    "vat": "b2MB",
    "invoice": 7088,
    "sag": 156
},
    {
    "id": 6335,
    "private_id": 202892445730,
    "Date": "2021-03-23",
    "Appendix": 4314,
    "Text": "yY6YJ",
    "Reconciliation_account": "JOeTrF",
    "creditor": 8486,
    "debtor": 3235,
    "accountno": 4652,
    "vat": "8dSVbO",
    "invoice": 8839,
    "sag": 457
},
    {
    "id": 6189,
    "private_id": 230477168617,
    "Date": "2019-07-30",
    "Appendix": 2482,
    "Text": "CoUk0S",
    "Reconciliation_account": "j7nPKI",
    "creditor": 3278,
    "debtor": 7739,
    "accountno": 3893,
    "vat": "mEILfE",
    "invoice": 266,
    "sag": 814
},
    {
    "id": 4770,
    "private_id": 763308707268,
    "Date": "2019-07-11",
    "Appendix": 9108,
    "Text": "LrR3sw",
    "Reconciliation_account": "GFGW1G",
    "creditor": 4594,
    "debtor": 8500,
    "accountno": 1918,
    "vat": "8X9ws",
    "invoice": 3045,
    "sag": 8688
},
    {
    "id": 7812,
    "private_id": 508374787584,
    "Date": "2016-11-11",
    "Appendix": 3173,
    "Text": "fsTR",
    "Reconciliation_account": "4UdsSA",
    "creditor": 8123,
    "debtor": 6667,
    "accountno": 7522,
    "vat": "lAsA",
    "invoice": 2973,
    "sag": 9896
}
]
for dat in data:
    inp = input("Yeni private key: ")
    dat["private_id"]= inp