UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xDg2y4M8IlbQ2CxV7WgsFUUxa+S4w1iv+O0tONMecfo=' 
WHERE 
  key_id = 'a4ac2c677c10313ae547d4f25e597364c769424a711cc67007a15db5bb7894c8' 
  AND (
    token = 'xDg2y4M8IlbQ2CxV7WgsFUUxa+S4w1iv+O0tONMecfo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027