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
}
]