After looking at the query a little more, I am not quire sure what you are trying to do. It looks to me like you are just trying to update the records for a given address key. In that case something like this would work. Can you give a little background on what you are trying to do?
update co_customer_x_address
set cxa_on_hold_flag = '1'
Where cxa_adr_key = '4490a7ff-cbfe-4386-8643-ec8cec854410'