UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'qX2ZvQ3bI35SIMBqf/z9UKz61BHABzhGBHERynwQfAI=' 
WHERE 
  key_id = 'd139f1a9f6cfdff2b29d9f246f31357afb2e09d3f4bc6ae11bf446730cba4bf3' 
  AND (
    token = 'qX2ZvQ3bI35SIMBqf/z9UKz61BHABzhGBHERynwQfAI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040