UPDATE
icpar_app.`transaction` t1
LEFT JOIN
icpar.`transaction` t2
ON
t1.id COLLATE utf8_general_ci = t2.nid COLLATE utf8_general_ci
SET
t1.approval = 'pending'
WHERE
t2.nid IS NULL
AND
t1.approval = 'paid'