UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pOrfe6i82/LMBW+Ea5max+s41e5Fg0LID2/HgxRdxHw=' 
WHERE 
  key_id = '29844112ce730a383a1f865864db348211491bd1fcfa41e225a3d123508339db' 
  AND (
    token = 'pOrfe6i82/LMBW+Ea5max+s41e5Fg0LID2/HgxRdxHw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032