UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6RsVBEmi94VEwUMiPyZ96cCRl0idhjFkJKOlLPS0roE=' 
WHERE 
  key_id = '1e0ee1c7ebe1953d434955178468f9044eecc447f1ed71cd80cd2743aa6b836c' 
  AND (
    token = '6RsVBEmi94VEwUMiPyZ96cCRl0idhjFkJKOlLPS0roE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032