UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'L3g07+RBc7ixRNnYstGePcLLd2sWxmnkmfjp/TiYHPc=' 
WHERE 
  key_id = '99e1412bf7cf2175a6df5f4909f1cb59ca434edd1c233c439ab4140d70dc56f8' 
  AND (
    token = 'L3g07+RBc7ixRNnYstGePcLLd2sWxmnkmfjp/TiYHPc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022