UPDATE not working

[Steve Spence]

My query is:

const char UPDATE_DATA[] = "UPDATE spspence_jobqueue.currentstatus SET pinID = pinValue WHERE deviceID = deviceID";

I'm calling it as such:

char pinID[6];

pinID = "pin_4"; // could be other values, pin_5, pin_6, all valid column names

my_conn.cmd_query(UPDATE_DATA);

get error:

Error: 47 = Unknown column 'pinID' in 'field list'.