UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '09NK0nOA4aw3U0RPfq0shTysCvVO58wEBJ64070OVHc=' 
WHERE 
  key_id = '7db4aeba0400c5d2f13e7639982d32423b941ad367a36175f49fd618f9224409' 
  AND (
    token = '09NK0nOA4aw3U0RPfq0shTysCvVO58wEBJ64070OVHc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027