To verify if the incoming data already exists, use the “Select matching database rows” action with the key field.
After that, split your incoming dataset into two parts: new data and changed data. Use the “Export to database” action to insert new data, and the “Update database” action to update data in Redshift.