UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'CAP7KmxAELEm3f5MWM8rEr3j4XmH2nVFBRk9D0snZPo=' 
WHERE 
  key_id = 'ed4c02d7acfa6292b7b9cd3ec07aab6ff80b9c0f66a3b0cc5e2307f8143175cc' 
  AND (
    token = 'CAP7KmxAELEm3f5MWM8rEr3j4XmH2nVFBRk9D0snZPo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036